UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8vPmLoFmwRek+RW28ZbeuGkmODEYs/DfZWqlc1nS/I='
WHERE
key_id = '3379c9e6cd382eec3aadb69a51a685186f278f96e89c74075ad1f8cd43a660b8'
AND (
token = 'J8vPmLoFmwRek+RW28ZbeuGkmODEYs/DfZWqlc1nS/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)