UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnjWBBUHTdCdbIYa+xtfpC1VxeWcZ/kfZfNn7mMvyfU='
WHERE
key_id = 'dc6d2bcec0d5f4bc4cee5ba0ecef768e9a29e98a746b8fadb1a05859d208de00'
AND (
token = 'pnjWBBUHTdCdbIYa+xtfpC1VxeWcZ/kfZfNn7mMvyfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)