UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZ4dQT0vegxRAGnfzY3J7cypcTxccX1dCO/hDZVBPhw='
WHERE
key_id = 'fc78980bf01062c16d02e701955bd6e0fb852a4fb3fece05ceee39c8ede85513'
AND (
token = 'PZ4dQT0vegxRAGnfzY3J7cypcTxccX1dCO/hDZVBPhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)