UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3pekqUKH9tiCfHDQbQN65+rZur+H2g8spBWQ45EFoeA=' 
WHERE 
  key_id = '6d25e60f2f565be915feafae02442c24e322193c94e103ecb3b64b9c61153700' 
  AND (
    token = '3pekqUKH9tiCfHDQbQN65+rZur+H2g8spBWQ45EFoeA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033