UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prNH5vdfxkoMJT2hF4g9rMeWvY6PecTT8ysBof/3dP8='
WHERE
key_id = '914300ae3185bc19713e8696447c8d91e314a64e3647efaa78ae787286ada85b'
AND (
token = 'prNH5vdfxkoMJT2hF4g9rMeWvY6PecTT8ysBof/3dP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)