UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0QJjK9wqay7+A0c/tGSzImt5zvNt68qAZf1SoZaW/Lg=' 
WHERE 
  key_id = '644a4cd820f795a815c297e50341dec1b68382184c87bae37f2b7ea4f5cc84ff' 
  AND (
    token = '0QJjK9wqay7+A0c/tGSzImt5zvNt68qAZf1SoZaW/Lg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024