UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GWEkK6x50fNrTP19xmvLjc2T3351ZBsoEaMi30yBNo='
WHERE
key_id = 'bc11b90237ef67eb360e7b25fa83f5afd1a786b697afe4f31179fe1130e0ad7c'
AND (
token = '5GWEkK6x50fNrTP19xmvLjc2T3351ZBsoEaMi30yBNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)