UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u6Gq7VeeSkkbGhF3vDJPzeY25Kk1AHQNMPwx9ek119k='
WHERE
key_id = '1f71689aefaebb14a5602c7c4cd9809a5f7af32e416be688e59f45e6c29420df'
AND (
token = 'u6Gq7VeeSkkbGhF3vDJPzeY25Kk1AHQNMPwx9ek119k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)