UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+UhTpgI3SKNUUp/PenfXlw7b1cS2a6qf4hF6QR/gBK0=' 
WHERE 
  key_id = '0d8a13005e5a0d21e53fc29e060fdba21bc7486a0f2383c51e4c66d03b4d793b' 
  AND (
    token = '+UhTpgI3SKNUUp/PenfXlw7b1cS2a6qf4hF6QR/gBK0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036