UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '06h7eGBgSbytaJqQIdcTYFPVUyKRpBO1xB4PPSz1cgM=' 
WHERE 
  key_id = '20e83e047a8ac1a07dee7a7e4b7296236eda5f359c0d9e6d060c8715334dc5ae' 
  AND (
    token = '06h7eGBgSbytaJqQIdcTYFPVUyKRpBO1xB4PPSz1cgM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029