UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X1c+Nrl2Ji7WpH4UY8LIKGbbMQfTsjbL3GVQvioo+6I=' 
WHERE 
  key_id = '903eafd31ad4c1f2698afa3f30a91095f8492bf18f450ec5ff3c9d7ffabd5d28' 
  AND (
    token = 'X1c+Nrl2Ji7WpH4UY8LIKGbbMQfTsjbL3GVQvioo+6I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022