UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CE9abroVzEVc9+RA/PhNmE/H3DDU7xsxexNy7jT31pI='
WHERE
key_id = 'e8431e6ce8911b8f382f3bc10718686e1e47ca1bbd74c69d0c31ce6917cdf93f'
AND (
token = 'CE9abroVzEVc9+RA/PhNmE/H3DDU7xsxexNy7jT31pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)