UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BDsk2EM4j2kBxPRhkjAM6ZD28OrM2soG9mBLK54utg='
WHERE
key_id = 'e677881c2a54ce46ed94bf2e62c1cee4469de04399df28c5a0b67faa143cee03'
AND (
token = '0BDsk2EM4j2kBxPRhkjAM6ZD28OrM2soG9mBLK54utg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)