UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pue84pz+DStP27S9NTBf5Z6lvVYanML6uNZWa6ixuU='
WHERE
key_id = '2ee9b88665f66376185c4e80ec9ef9e9384917920f7652f0584adce672a0fc37'
AND (
token = '0pue84pz+DStP27S9NTBf5Z6lvVYanML6uNZWa6ixuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)