UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fz6Fik09oa01pT41hHus8li3+5WgdERlsb4yEWuyISo=' 
WHERE 
  key_id = '5465be8651fcf0a931904373da45e61303906e5d7403b4ae5b5bb987cc04d1e9' 
  AND (
    token = 'fz6Fik09oa01pT41hHus8li3+5WgdERlsb4yEWuyISo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029