UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '74NBH+EKs7Dv8DMTP1bNlSKn0ay5X0PGMlFRirNou4Y='
WHERE
key_id = '4f49a610a27d319a1beb507d677f455c61a2c8b2617bb97356df865ed71bcf0e'
AND (
token = '74NBH+EKs7Dv8DMTP1bNlSKn0ay5X0PGMlFRirNou4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)