UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q1/TOGcecFHn6+475HNF6MCI4sP59Xzj8gihGd+fIN4=' 
WHERE 
  key_id = 'd7e769d4a83fa175a7a1c7f5678a97deca7d181fdedaa1830b58f51627a6a55a' 
  AND (
    token = 'Q1/TOGcecFHn6+475HNF6MCI4sP59Xzj8gihGd+fIN4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024