UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kKTq/GNZUPiua9q6ToQz8tEsfr8SPNv42RR9w30WFyw='
WHERE
key_id = 'bce6456e4d57994748741614904a8b3cf718daf40f8f206945bc81e6ff66fb5e'
AND (
token = 'kKTq/GNZUPiua9q6ToQz8tEsfr8SPNv42RR9w30WFyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)