UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ntiy4G8eX4qvZfSWanM1bW5Ha1dA3I70Uid7GwZAqCg=' 
WHERE 
  key_id = '9d60df225e0a7a167133f86e7e194778ab76b9013dbbe422c41d4e261e83d83e' 
  AND (
    token = 'Ntiy4G8eX4qvZfSWanM1bW5Ha1dA3I70Uid7GwZAqCg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044