UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRdczqyN7fB7nSkIfbKfyV01gH+bZ6lF7USCo1x9E1I='
WHERE
key_id = 'd72dd07eddeb08935a3470cb6e5e8228003964d23ba9613492287ef128ec802f'
AND (
token = 'xRdczqyN7fB7nSkIfbKfyV01gH+bZ6lF7USCo1x9E1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)