UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yA5ZF4TkmcwTHaMma8e9M97PsBVhA7i/kir9DOYZZDw=' 
WHERE 
  key_id = '22bc43ff237cac8bf82d56125e0ce40d5d1becda1bd7af80126944c88e2eed12' 
  AND (
    token = 'yA5ZF4TkmcwTHaMma8e9M97PsBVhA7i/kir9DOYZZDw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034