UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnDyrrpCx1ESI3toUOK3Q5g/hSQECAWaUoq3MYtrS4Y='
WHERE
key_id = 'dc2ff28ecced78bf893a2cd0d86b7ece74821bafa1209878c3390e83fedafc9a'
AND (
token = 'YnDyrrpCx1ESI3toUOK3Q5g/hSQECAWaUoq3MYtrS4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)