UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gRFqy8ui4pwTBGmvmFLYYEZdis84a+dszuschkVzlVw=' 
WHERE 
  key_id = '844fbee84a54892b6e6d4ab86daba11024140ba70f8acd6c43fd778604c61403' 
  AND (
    token = 'gRFqy8ui4pwTBGmvmFLYYEZdis84a+dszuschkVzlVw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025