UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yo4vV0yUgzcSH+j9qa6BKuU8ZTHpDekA767QK4ZVP4='
WHERE
key_id = '7c0786288968b034ebba82a63c6f8847f40cca178db300ed270ddf18f9706a98'
AND (
token = '7yo4vV0yUgzcSH+j9qa6BKuU8ZTHpDekA767QK4ZVP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)