UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YzdfARJI1nyDEM1vKWOxrk233TdtPfKOwF1tWFY6gms='
WHERE
key_id = 'e836581a98af5d69440068e64ddf3e1211b9bca02de11a89c77c00a9fc732197'
AND (
token = 'YzdfARJI1nyDEM1vKWOxrk233TdtPfKOwF1tWFY6gms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)