UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4h797t4fjNvw6OH83coQvs3wI2QyWavFZOAVB4HR1M0='
WHERE
key_id = '4b91440a5793623d8a1dc2ac2d27120abc22d9e48c0b2da8674036e538e9249e'
AND (
token = '4h797t4fjNvw6OH83coQvs3wI2QyWavFZOAVB4HR1M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)