UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SR/ShW4rz5LH9kescyAxmZmHEVYQeEG9kJsg6FOl/dU='
WHERE
key_id = '77660ba6bd454615d8fa45fa95f8141121c633dc92d86fbc7acad7d7a91b71b3'
AND (
token = 'SR/ShW4rz5LH9kescyAxmZmHEVYQeEG9kJsg6FOl/dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)