UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'diwhfKkN2NCAhRr6SgoX3haQD6fuKspI6teaBDMat7Q='
WHERE
key_id = 'cc2dec712899c88a6b48c8d82af1955b515c8cf51e796a201f1839d0c69b5658'
AND (
token = 'diwhfKkN2NCAhRr6SgoX3haQD6fuKspI6teaBDMat7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)