UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hX5hynjsO7on9fxCh2zCmFBcg6bHGKMTqi9r6BBqNNs='
WHERE
key_id = '769e7b8615bc54742a88c084099d999b7e0621f5e9db8534a0487275abc275ad'
AND (
token = 'hX5hynjsO7on9fxCh2zCmFBcg6bHGKMTqi9r6BBqNNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)