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