UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hVyrO4GhYTOr8PMwZXKu3QQ8E0ls72B5Dm/YK3/Zaes=' 
WHERE 
  key_id = '1b93a1bf0fa1e31622428b56fc1b5b8944b8b76662a85a734c770512529ee991' 
  AND (
    token = 'hVyrO4GhYTOr8PMwZXKu3QQ8E0ls72B5Dm/YK3/Zaes=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017