UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNZmA0R4Q2RL9l8Kkc6CWE1syH3pNZ33xaFr+nZuG08='
WHERE
key_id = '786323e7400b8054bfbdf827c95665e2b833651c278f500d3bd0cd0584baaf42'
AND (
token = 'TNZmA0R4Q2RL9l8Kkc6CWE1syH3pNZ33xaFr+nZuG08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)