UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0HaVM/Yo4F5AD0z27u1XQg8Mok59OdUT39hub1VB8jM=' 
WHERE 
  key_id = '1b4677b9c39d2f5873dce12e20372b096839ba4b08df3f1f1263dcb16a256690' 
  AND (
    token = '0HaVM/Yo4F5AD0z27u1XQg8Mok59OdUT39hub1VB8jM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021