UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1ysSKQL5BxBBVYTY0rbIKUxYGiX33++X1F2b40yZ1k='
WHERE
key_id = '8a23a61cdb635e0369c47ea43cda5ced37bdbbfc1bdfffc74ed136577a35eade'
AND (
token = 'J1ysSKQL5BxBBVYTY0rbIKUxYGiX33++X1F2b40yZ1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)