UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZUTUwXS88bhbQy5N1RPP58AkICKF55UtIsMzbLpIbQ='
WHERE
key_id = '78064c554071d1bf1e9b9aa006414750d3bed14d4b0ac873b0448fbbb4bea456'
AND (
token = '8ZUTUwXS88bhbQy5N1RPP58AkICKF55UtIsMzbLpIbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)