UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Akg/VH8Lt92AKoX/AnYwqXX9Qlj4FXRKFzTsFasMMmA=' 
WHERE 
  key_id = 'd39b62a49bfe85fa7a26d39e3c0f695571dc75e1d56416fe2f9e8c8fa7d9e0e4' 
  AND (
    token = 'Akg/VH8Lt92AKoX/AnYwqXX9Qlj4FXRKFzTsFasMMmA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029