UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xIdTNdrGuizr2GFzId6tCbUdBRaXaOGN+qWTm/6O9xA='
WHERE
key_id = 'ffcf7d0d17b5b3adc7e243ddd7a6db356f29fe152854436c97eab1253b2641d1'
AND (
token = 'xIdTNdrGuizr2GFzId6tCbUdBRaXaOGN+qWTm/6O9xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)