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