UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'q2Hk3j3AA81OrcxXsCMC0325sK/Uydm3n4ou/3rJWHM=' 
WHERE 
  key_id = '4da6f16e7ac24e7285df3eed98a9b2f68f3f61bab67640fec504bf895b91c0f5' 
  AND (
    token = 'q2Hk3j3AA81OrcxXsCMC0325sK/Uydm3n4ou/3rJWHM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033