UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QmL6c3Zq7qKNE+pmo2jEtz9g33GG2uKO9ep4ZN/4acw=' 
WHERE 
  key_id = '37e9e8342ba9f57c68c846d6bddfb7f5d7660cfbe1f8d41d5f72b0afbe068456' 
  AND (
    token = 'QmL6c3Zq7qKNE+pmo2jEtz9g33GG2uKO9ep4ZN/4acw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029