UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A8UZbITvSYpPz8mZhN5w69LpHJd/MiTMtyHXjUlV3rw='
WHERE
key_id = 'aa12f59072571d782b62467f233b929b583f4300d7b8592ce6fe37fb895b24ff'
AND (
token = 'A8UZbITvSYpPz8mZhN5w69LpHJd/MiTMtyHXjUlV3rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)